#-*- coding:utf-8 -*-
import requests, time,sys,re
import urllib, zlib
import pymysql
# from trace import ConverageResults
import json

HOST = 'localhost'

def readSQLcase():
    sql="SELECT id,`apiname` apiurl,apimethod,apiparamvalue,apiresult,`apistatus` from apitest_apistep where Apitest_id=3"
    conn = pymysql.connect(user='root', password='123456', db='baihuidb', host='localhost',port='3306',charset='utf-8')
    cursor = conn.cursor()
    sql_res = cursor.execute(sql)
    info = cursor.fetchmany(sql_res)
    for i in info:
        case_list = []
        case_list.append(i)
        # interfaceTest(case_list)
    conn.commit()
    cursor.close()
    conn.close()

